﻿CREATE TABLE [flcrTM].[SERVICE_DEVICE_XREF] (
    [TM_SERVICE_DEVICE_XREF_ID] INT           IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]                  INT           NOT NULL,
    [SERVICE_DEVICE_XREF_ID]    INT           NOT NULL,
    [AUDIT_USER]                VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]                DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]             INT           NOT NULL,
    [AUDIT_MOD_USER]            VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]            DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]         INT           NOT NULL,
    [WRKFL_ITEM_ID]             INT           NOT NULL,
    [WRKFL_STATUS_ID]           INT           NOT NULL,
    [ACTIVE_FLG]                BIT           NOT NULL,
    [ENV_ID]                    INT           NOT NULL,
    [DEVICE_ID]                 INT           NOT NULL,
    [SERVICE_ID]                INT           NOT NULL,
    [SERVICE_TYPE]              INT           NOT NULL,
    [RESOURCE_ID]               INT           NOT NULL,
    [SLA_ID]                    INT           NOT NULL,
    [PARENT_ID]                 INT           NULL
);

